UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SeN47hfkk5fufgY+B1YOpXVUCKs91ACf81XILHdRSRc='
WHERE
key_id = 'bad0c21449dae9bb00de08df5fc84c89451b8674bd1292b1752964c88fe6bcd7'
AND (
token = 'SeN47hfkk5fufgY+B1YOpXVUCKs91ACf81XILHdRSRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)