UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iRW0uIFbsXEr2KQSSD4q4QhyTEkzG+z3F8E0CjT9CDs='
WHERE
key_id = 'b923a4b128eeab4f914b4ba3b78a33ad2b1c936a34daf8719f3d859eb3162637'
AND (
token = 'iRW0uIFbsXEr2KQSSD4q4QhyTEkzG+z3F8E0CjT9CDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)