UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sT5dC3OHO01GCGyoTeCjoE7Bq/hdD6OJxqJvgZj7vEE='
WHERE
key_id = 'c2efb58ddf51d237a150dbb6f4b566dd37420288c7b04b4eede265a08f4618b3'
AND (
token = 'sT5dC3OHO01GCGyoTeCjoE7Bq/hdD6OJxqJvgZj7vEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)