UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2C29+XJsuPlsFAdX9EasfikNOkl0VXbdEHFScDTp9ZI='
WHERE
key_id = '8e277207c9855d0d203562b2579e3250b602013608ed01d3ff3007f56e0f370f'
AND (
token = '2C29+XJsuPlsFAdX9EasfikNOkl0VXbdEHFScDTp9ZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)