UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXAIyD6C5ymQIAbzcKO+bEGa606dU5C61MVRfSzOGnI='
WHERE
key_id = 'bca3b01aa46d61f7f38e1bde813fea4bb556d7be4571a4542f2e1d3742f295d9'
AND (
token = 'yXAIyD6C5ymQIAbzcKO+bEGa606dU5C61MVRfSzOGnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)