UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WaMHLG5bzG+1+svWxpvI62yKqF0La30n8atWSofuzvE='
WHERE
key_id = 'd8befd0938bce3e847bce73ef505dc578cda22c956d45f71f6fbd9bdcaa4ecab'
AND (
token = 'WaMHLG5bzG+1+svWxpvI62yKqF0La30n8atWSofuzvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)