UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zOTAOyb3Ry3eNz2wtnZeQO5z3wAojEIodkMZJbnBo40='
WHERE
key_id = '9303c79f35e22f3383d5565d01371f5599a5be6e551e6831d6f161665b8dc539'
AND (
token = 'zOTAOyb3Ry3eNz2wtnZeQO5z3wAojEIodkMZJbnBo40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)