UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBIvDGeVUhVOCDdp27E3KlvAMJ/sSk1v751YcOipgyI='
WHERE
key_id = 'e5b0976fc1f5bc49378feb07ce46b90fe2ea1bd1263f69f8c049a1e6d9f109dd'
AND (
token = 'pBIvDGeVUhVOCDdp27E3KlvAMJ/sSk1v751YcOipgyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)