UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y5MCpAI+yM/N43EYJyt8cwEkypvk+69CFgX+347USlA='
WHERE
key_id = '8ccad4f45fad7b26d6f2fc9726914782b4de792dae06536d8e09bd3a04b3dc86'
AND (
token = 'y5MCpAI+yM/N43EYJyt8cwEkypvk+69CFgX+347USlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)