UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Xq9FRlCaLn+xu9YViC8+S6LyKFdWAVzUm3NyZb8QxM='
WHERE
key_id = 'df200add59c6be132149ea734f2f56865a62068bdc600a121fc2cc3463980038'
AND (
token = '1Xq9FRlCaLn+xu9YViC8+S6LyKFdWAVzUm3NyZb8QxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)