UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNkc18jg9ZBaEOQOQvKWOAvID3cOXxGoFjZiAp4+kU8='
WHERE
key_id = '1127979eb62e24d51b75cf373cb57f65870edb230516b9c298d94045716aef0f'
AND (
token = 'NNkc18jg9ZBaEOQOQvKWOAvID3cOXxGoFjZiAp4+kU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)