UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1oBsR0DB7KmGtuT0sQDiRl0pNWLLBBi5ShvWHK6vErc='
WHERE
key_id = 'd4f347c58cb1545956643656bae72cb449dd7fbe6dea873015fdae4e9722d4c9'
AND (
token = '1oBsR0DB7KmGtuT0sQDiRl0pNWLLBBi5ShvWHK6vErc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)