UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zp/Q2nM735qoe8pispEOFlCmY9Qwb1sJCwWMM5mWSSA='
WHERE
key_id = '9ea0824a8883f6ede2e33055f654b1e7888637707e60170db81cbe14bb7809b1'
AND (
token = 'Zp/Q2nM735qoe8pispEOFlCmY9Qwb1sJCwWMM5mWSSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)