UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jd58zKAbC1d/kANZozkmCU1khcoq6OU+q5EG7eQ4O6I='
WHERE
key_id = 'bcd0e4919a48900cf29b4266e8678eeecc00ee6e57adc246624a7f11ac4cdd95'
AND (
token = 'Jd58zKAbC1d/kANZozkmCU1khcoq6OU+q5EG7eQ4O6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)