UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4A9qGrt+0kVcs4KVfI0bt37hdjqAvUe5HIWsWJCZ0Y='
WHERE
key_id = '8a50a109168da8c78d7dfcd892c4e0897ec859aab4adf423919960170a0805fa'
AND (
token = 'd4A9qGrt+0kVcs4KVfI0bt37hdjqAvUe5HIWsWJCZ0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)