UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9994duLIiZDFWVslzhREV6eWTopoQxxY62c5jFU7Pw='
WHERE
key_id = '6e2493c06fceb80c4567caa02f07672b960f190238d32415fb667c50024f3ec5'
AND (
token = 'D9994duLIiZDFWVslzhREV6eWTopoQxxY62c5jFU7Pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)