UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rq5bMHwfV1LWxr+309M01VEizAqs747dzGrOJf+vYc='
WHERE
key_id = '287a8fddb6b7675eb6a3fdd41226ce9fde651e1900e47fb03ef0d99bf6e98139'
AND (
token = '9rq5bMHwfV1LWxr+309M01VEizAqs747dzGrOJf+vYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)