UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBJTLPfdCeGBYNdqMN7d0BnJfT0L9couJAcoNH08G3k='
WHERE
key_id = '4484e38850561f2633fc449c74d9989a87291d69e6c86a89e9a013ed6e88d144'
AND (
token = 'qBJTLPfdCeGBYNdqMN7d0BnJfT0L9couJAcoNH08G3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)