UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjPCrUKDc60F7wc22EdjTfiMZVL+3dwMtCRXkSBUFc8='
WHERE
key_id = '17a9be32f5eda45f7b57ceddd84c181e04567413a882270152a5955dde6222b2'
AND (
token = 'XjPCrUKDc60F7wc22EdjTfiMZVL+3dwMtCRXkSBUFc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)