UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ETypWfYi73KWCbw1LGoOVA41rACOm6B0QJN4bfMmVtU='
WHERE
key_id = '0cb9c9e70ff2eb087fb978225a7d96ce7a305379a43aa1b9f79337d53673e466'
AND (
token = 'ETypWfYi73KWCbw1LGoOVA41rACOm6B0QJN4bfMmVtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)