UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1jhf8O7Wmu8xMmEv0DSZ3CQKL+Q3r35sMKP/G1DJhs='
WHERE
key_id = 'eaeb42a55277ea771a0713a20a1b57798238848327d515fb624e70a06a4fff6a'
AND (
token = 'k1jhf8O7Wmu8xMmEv0DSZ3CQKL+Q3r35sMKP/G1DJhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)