UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EJzvO+bwLIrVZczV9a9nmDpFi9C2wJLOjTo28XiLLZI='
WHERE
key_id = '212cdf8c23778535ed7918220b46ed32949b4fb098ce8f27a8e4df9f2b8f63dd'
AND (
token = 'EJzvO+bwLIrVZczV9a9nmDpFi9C2wJLOjTo28XiLLZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)