UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5HDsEA8tpjaGTGj2exQTi7n42/kvC2r65Xx89L3Bcs='
WHERE
key_id = 'efdd5875bde0825ac1a1a43c643c41aa5ea8faf0ec35cd7e3b769070a9de5a45'
AND (
token = 'X5HDsEA8tpjaGTGj2exQTi7n42/kvC2r65Xx89L3Bcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)