UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KmQgyxSkMAxoxczc4hE38CvkPBCvRA6OEXry9rs8Gds='
WHERE
key_id = '0cba823af9a17f545a8be284c4f01422243faa515fcf3be5f4b9511b404aefe1'
AND (
token = 'KmQgyxSkMAxoxczc4hE38CvkPBCvRA6OEXry9rs8Gds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)