UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ayJDWNcTWBr91aQFJE8jvnbEjxSVzWHD9I/EP2i9uU='
WHERE
key_id = 'd946052a1f676a1579ae1ca46f47674bfcb472c4228ed1193acc3fa9ffdc3c9c'
AND (
token = '2ayJDWNcTWBr91aQFJE8jvnbEjxSVzWHD9I/EP2i9uU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)