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