UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8TBA3V/tsoz+dHCZO9UdI+zgwLbj5X3Xcncxgpupa4='
WHERE
key_id = '6423472ba10a62b89abfc9c9fbd7efec1bc366f42f5266e8d2ff35264d2828a7'
AND (
token = 'N8TBA3V/tsoz+dHCZO9UdI+zgwLbj5X3Xcncxgpupa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)