UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9U/KqKbYCzvZS7YlW2V5ZVTQxhiMr/z1kCezCxOpFg='
WHERE
key_id = '0f4f32dd4422e78d74eb33529511befec1c3a9276102adc73ed9eb8d320f4924'
AND (
token = 'G9U/KqKbYCzvZS7YlW2V5ZVTQxhiMr/z1kCezCxOpFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)