UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ILq1rJ2+KAwfr3y5NicpYVd3x8L9G917M177Gb4tAfk='
WHERE
key_id = 'b230500f8a5d91a1ab4ac7dbee9f5e8e1605cc6b3b526428ec556c8bb98cf27c'
AND (
token = 'ILq1rJ2+KAwfr3y5NicpYVd3x8L9G917M177Gb4tAfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)