UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zV+ZKJ+QmyvmSzfWhCvyubxb9nH2ClcPmyRavDyrLqw='
WHERE
key_id = '6d061a8898e95a29c0c52b2a5dd132b004c60951d2ef92defad95a65db272265'
AND (
token = 'zV+ZKJ+QmyvmSzfWhCvyubxb9nH2ClcPmyRavDyrLqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)