UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKaM8HRnGuIsFXqSS65DaCYA1FMBqdovG8UKaJO5qFM='
WHERE
key_id = '7d4fac05d1f6192628e01409ec097650dd1b368661301d442a524a64deeaf7b1'
AND (
token = 'pKaM8HRnGuIsFXqSS65DaCYA1FMBqdovG8UKaJO5qFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)