UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tgdy9XSVupYp+2Vu/yyXbfnp1tmGX0yDCT/k6izNCy0='
WHERE
key_id = '99aed96c671439482f87270bae5af2a37443914c9d22f6bfae39dc75743db025'
AND (
token = 'tgdy9XSVupYp+2Vu/yyXbfnp1tmGX0yDCT/k6izNCy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)