UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZR96EbOnnfbUjnz720nDh3QwMmDd1MyjdbtVe6KUB3s='
WHERE
key_id = 'a4cfcb0def84c921004ee00359690365e6f173fa07021ddd6d72b2dca62ff7f6'
AND (
token = 'ZR96EbOnnfbUjnz720nDh3QwMmDd1MyjdbtVe6KUB3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)