UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ps/Kl1ILS7n8f1wP8ZuF2Jzi638or4wEjtCKn+1ILmM='
WHERE
key_id = '6ee6a11fe9bd14406a5d1f73a3ed94dd41ac3376ddfd6476ab0655f8cc2b9cf2'
AND (
token = 'Ps/Kl1ILS7n8f1wP8ZuF2Jzi638or4wEjtCKn+1ILmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)