UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RQgOHMFKE78OSENIr3RE9Db/pxq7UqZ6BZy999ZOnAs='
WHERE
key_id = '485feb315c431bd253c885581d668f487a5000ee1490b37d7f3459719b15242f'
AND (
token = 'RQgOHMFKE78OSENIr3RE9Db/pxq7UqZ6BZy999ZOnAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)