UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DGqQgzqXEOqF1c2hZw/DVxi6TKFF/sRRUfda6n3hwd0='
WHERE
key_id = 'd1186c543d56c18df407c07b19d3bedb94063987331f70a9788eb17b59938213'
AND (
token = 'DGqQgzqXEOqF1c2hZw/DVxi6TKFF/sRRUfda6n3hwd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)